package com.huike.business.mapper;

import java.util.List;
import com.huike.business.domain.TbBusinessTrackRecord;
import com.huike.business.domain.vo.BusinessTrackVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * 商机跟进记录Mapper接口
 * @date 2021-04-28
 */
public interface TbBusinessTrackRecordMapper {

    @Insert("insert into tb_business_track_record (business_id,track_status,next_time,key_items,record) " +
            "values (#{businessId},#{trackStatus},#{nextTime},#{keyItems},#{record})")
    void add(BusinessTrackVo businessTrackVo);

    @Update("update tb_business set name =#{name},phone = #{phone},occupation =#{occupation},education =#{education},provinces = #{provinces},city = #{city},sex = #{sex},age =#{age},weixin =#{weixin},qq =#{qq},subject =#{subject},job =#{job},salary =#{salary},reasons =#{reasons},other_intention =#{otherIntention}")
    void updateBuss(BusinessTrackVo businessTrackVo);



    @Select("select * from tb_business_track_record where business_id = #{id}")
    List<TbBusinessTrackRecord> selectTbBusinessTrackRecord(Long id);


}